package 把成绩插入到数据库;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.util.ArrayList;

public class 把成绩插入到数据库 {

	public static void main(String[] args) throws Exception {
		BufferedReader br = new BufferedReader(new FileReader(new File("D://29.txt")));
		StringBuilder sb = new StringBuilder();
		ArrayList<String> al = new ArrayList<String>();
		String line = null;
		while ((line = br.readLine()) != null) {
			String[] a = line.split("\u0009");
			String tmp = "";
			tmp += "INSERT INTO c9 VALUES ( '" + a[0] + "', '" + a[1] + "', '" + a[2] + "', '" + a[3] + "', '" + a[4]
					+ "', '" + a[5] + "', '" + a[6] + "', '" + a[7] + "', '" + a[8] + "', '" + a[9] + "', '" + a[10]
					+ "' );";
			System.out.println(tmp);
			al.clear();
		}
		System.out.println(sb.toString());
		br.close();
	}

}
